INSERT INTO [pwqkcjxt].[dbo].[F_OUTPUT]
([qiyeid]
      ,[SERIAL]
      ,[OUT_NAME]
      ,[POLLUTE_TYPE]
      ,[XAIS]
      ,[YAIS]
      ,[LOGOUT_FLAG]
      ,[IF_DECT]
      ,[BEGIN_TIME]
      ,[FUNCTION_REGION]
      ,[PERIOD_ID]
      ,[OUT_DIRECTION]
      ,[WATER_FACTORY_ID]
      ,[GATHER_OUTPUT]
      ,[VALLEY_CODE]
      ,[TRADE_CODE]
      ,[OUTPUT_POSITION]
      ,[SOUND_OUT_TYPE_ID]
      ,[IF_WORKSHOP]
      ,[WATER_OVER_MULTIPLE]
      ,[OUTPUT_MAP]
      ,[GAS_HIGHT]
      ,[RADIUS]
      ,[COAL_CODE]
      ,[PRODUCT_COUT]
      ,[OUTPUT_CODE]
      ,[OUTPUT_TYPE]
      ,[FACILITY_NAME]
      ,[WORKSHOP_NAME]
      ,[IF_TWOAREA]
      ,[OUT_RULE]
      ,[OUT_MONTH]
      ,[OUT_TYPE]
      ,[MACHINE_NAME]
      ,[BOIL_STYLE]
      ,[BOIL_USEFOR]
      ,[GAS_TECHNICS]
      ,[STANDARD_LEVEL]
      ,[isexport]
      ,[suoding]
      ,[system])
      
      SELECT 
        SUBSTRING(FACT_ID,5,2)+RIGHT(FACT_ID,4)
      ,[SERIAL]
      ,[OUT_NAME]
      ,[POLLUTE_TYPE]
      ,[XAIS]
      ,[YAIS]
      ,[LOGOUT_FLAG]
      ,[IF_DECT]
      ,[BEGIN_TIME]
      ,[FUNCTION_REGION]
      ,[PERIOD_ID]
      ,[OUT_DIRECTION]
      ,[WATER_FACTORY_ID]
      ,[GATHER_OUTPUT]
      ,[VALLEY_CODE]
      ,[TRADE_CODE]
      ,[OUTPUT_POSITION]
      ,[SOUND_OUT_TYPE_ID]
      ,[IF_WORKSHOP]
      ,[WATER_OVER_MULTIPLE]
      ,[OUTPUT_MAP]
      ,[GAS_HIGHT]
      ,[RADIUS]
      ,[COAL_CODE]
      ,[PRODUCT_COUT]
      ,[OUTPUT_CODE]
      ,[OUTPUT_TYPE]
      ,[FACILITY_NAME]
      ,[WORKSHOP_NAME]
      ,[IF_TWOAREA]
      ,[OUT_RULE]
      ,[OUT_MONTH]
      ,[OUT_TYPE]
      ,[MACHINE_NAME]
      ,[BOIL_STYLE]
      ,[BOIL_USEFOR]
      ,[GAS_TECHNICS]
      ,[STANDARD_LEVEL]
      ,[isexport]
      ,0
      ,0
      FROM dbo.F_OUTPUT